package com.yycwxt.modules.admin.shop;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yycwxt.domain.Flowfee;
import com.yycwxt.domain.Shop;
import com.yycwxt.domain.Store;
import com.yycwxt.domain.Subject;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface ShopMapper extends BaseMapper<Shop> {
//    @Select("select * from glb_shop where name = #{name}")
//    List<Shop> selectByName(String name);

//    @Select("select * from glb_shop")
//    List<Shop> selectAll();
//
//    @Delete("delete from glb_shop")
//    int deleteAll();

//    @Insert("insert into glb_shop(code, name, platform, type) values (#{code},#{name},#{platform},#{type})")
//    int add(Shop shop);

    @Select("select * from glb_shop where id like concat('%',#{input},'%') or code like concat('%',#{input},'%')  or name like concat('%',#{input},'%') or fullname like concat('%',#{input},'%') or platform like concat('%',#{input},'%');")
    List<Shop> selectByInput(@Param("input") String input);



}
